﻿<?xml version="1.0" encoding="utf-8" ?> 
<AdoNetDataAccess connection="$ArticleDBConnection$" >
	<Sql>
		UPDATE ObjectTreeCounts SET
			treeName = N'Deleted' + ObjectTreeCounts.treeName
      ,dateUpdated = @dateUpdated
		FROM ObjectTreeCounts
			INNER JOIN  ObjectTreeNodes ON ObjectTreeCounts.objectId = ObjectTreeNodes.objectId
		WHERE
			(ObjectTreeNodes.parentHostId = @id)
	</Sql>
	<Param name="id" type="UniqueIdentifier"/>
  <Param name="dateUpdated" type="Date" />
</AdoNetDataAccess>
